Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 167693 |
| Missing cells | 480 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.6 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 1 |
ignore has constant value "0" | Constant |
open time is highly correlated with open and 4 other fields | High correlation |
open is highly correlated with open time and 4 other fields | High correlation |
high is highly correlated with open time and 4 other fields | High correlation |
low is highly correlated with open time and 4 other fields | High correlation |
close is highly correlated with open time and 4 other fields | High correlation |
volume is highly correlated with quote_asset_volume and 3 other fields | High correlation |
close_time is highly correlated with open time and 4 other fields | High correlation |
quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
number_of_trades is highly correlated with volume and 3 other fields | High correlation |
taker_buy_base_asset_volume is highly correlated with volume and 3 other fields | High correlation |
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
open time is highly correlated with open and 4 other fields | High correlation |
open is highly correlated with open time and 4 other fields | High correlation |
high is highly correlated with open time and 4 other fields | High correlation |
low is highly correlated with open time and 4 other fields | High correlation |
close is highly correlated with open time and 4 other fields | High correlation |
volume is highly correlated with quote_asset_volume and 3 other fields | High correlation |
close_time is highly correlated with open time and 4 other fields | High correlation |
quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
number_of_trades is highly correlated with volume and 3 other fields | High correlation |
taker_buy_base_asset_volume is highly correlated with volume and 3 other fields | High correlation |
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
open time is highly correlated with close_time | High correlation |
open is highly correlated with high and 2 other fields | High correlation |
high is highly correlated with open and 2 other fields | High correlation |
low is highly correlated with open and 2 other fields | High correlation |
close is highly correlated with open and 2 other fields | High correlation |
volume is highly correlated with quote_asset_volume and 3 other fields | High correlation |
close_time is highly correlated with open time | High correlation |
quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
number_of_trades is highly correlated with volume and 3 other fields | High correlation |
taker_buy_base_asset_volume is highly correlated with volume and 3 other fields | High correlation |
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fields | High correlation |
low is highly correlated with open time and 4 other fields | High correlation |
open time is highly correlated with low and 4 other fields | High correlation |
close_time is highly correlated with low and 4 other fields | High correlation |
number_of_trades is highly correlated with volume and 3 other fields | High correlation |
volume is highly correlated with number_of_trades and 3 other fields | High correlation |
taker_buy_quote_asset_volume is highly correlated with number_of_trades and 3 other fields | High correlation |
high is highly correlated with low and 4 other fields | High correlation |
taker_buy_base_asset_volume is highly correlated with number_of_trades and 3 other fields | High correlation |
open is highly correlated with low and 4 other fields | High correlation |
quote_asset_volume is highly correlated with number_of_trades and 3 other fields | High correlation |
close is highly correlated with low and 4 other fields | High correlation |
volume is highly skewed (γ1 = 20.69985771) | Skewed |
taker_buy_base_asset_volume is highly skewed (γ1 = 27.29847463) | Skewed |
taker_buy_quote_asset_volume is highly skewed (γ1 = 22.69475006) | Skewed |
open time is uniformly distributed | Uniform |
close_time is uniformly distributed | Uniform |
open time has unique values | Unique |
close_time has unique values | Unique |
volume has 33414 (19.9%) zeros | Zeros |
quote_asset_volume has 33414 (19.9%) zeros | Zeros |
number_of_trades has 33414 (19.9%) zeros | Zeros |
taker_buy_base_asset_volume has 70012 (41.8%) zeros | Zeros |
taker_buy_quote_asset_volume has 70012 (41.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-14 19:16:12.398787 |
|---|---|
| Analysis finished | 2022-02-14 19:16:56.090242 |
| Duration | 43.69 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
open time
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 167693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.629688153 × 1012 |
| Minimum | 1.6145568 × 1012 |
|---|---|
| Maximum | 1.64479662 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1.6145568 × 1012 |
|---|---|
| 5-th percentile | 1.616071428 × 1012 |
| Q1 | 1.62213426 × 1012 |
| median | 1.62969714 × 1012 |
| Q3 | 1.63725048 × 1012 |
| 95-th percentile | 1.643287392 × 1012 |
| Maximum | 1.64479662 × 1012 |
| Range | 3.023982 × 1010 |
| Interquartile range (IQR) | 1.511622 × 1010 |
Descriptive statistics
| Standard deviation | 8729706727 |
|---|---|
| Coefficient of variation (CV) | 0.005356673121 |
| Kurtosis | -1.20006685 |
| Mean | 1.629688153 × 1012 |
| Median Absolute Deviation (MAD) | 7558200000 |
| Skewness | -0.001590850162 |
| Sum | 2.732872955 × 1017 |
| Variance | 7.620777954 × 1019 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1.62151722 × 1012 | 1 | < 0.1% |
| 1.61873136 × 1012 | 1 | < 0.1% |
| 1.63716822 × 1012 | 1 | < 0.1% |
| 1.6215939 × 1012 | 1 | < 0.1% |
| 1.64401092 × 1012 | 1 | < 0.1% |
| 1.64064096 × 1012 | 1 | < 0.1% |
| 1.6293582 × 1012 | 1 | < 0.1% |
| 1.6182468 × 1012 | 1 | < 0.1% |
| 1.63817586 × 1012 | 1 | < 0.1% |
| 1.62048186 × 1012 | 1 | < 0.1% |
| Other values (167683) | 167683 |
| Value | Count | Frequency (%) |
| 1.6145568 × 1012 | 1 | |
| 1.61455698 × 1012 | 1 | |
| 1.61455716 × 1012 | 1 | |
| 1.61455734 × 1012 | 1 | |
| 1.61455752 × 1012 | 1 | |
| 1.6145577 × 1012 | 1 | |
| 1.61455788 × 1012 | 1 | |
| 1.61455806 × 1012 | 1 | |
| 1.61455824 × 1012 | 1 | |
| 1.61455842 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.64479662 × 1012 | 1 | |
| 1.64479644 × 1012 | 1 | |
| 1.64479626 × 1012 | 1 | |
| 1.64479608 × 1012 | 1 | |
| 1.6447959 × 1012 | 1 | |
| 1.64479572 × 1012 | 1 | |
| 1.64479554 × 1012 | 1 | |
| 1.64479536 × 1012 | 1 | |
| 1.64479518 × 1012 | 1 | |
| 1.644795 × 1012 | 1 |
| Distinct | 109864 |
|---|---|
| Distinct (%) | 65.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3031.148652 |
| Minimum | 1415.01 |
|---|---|
| Maximum | 4861.97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1415.01 |
|---|---|
| 5-th percentile | 1771.492 |
| Q1 | 2290.52 |
| median | 3062.54 |
| Q3 | 3788.48 |
| 95-th percentile | 4443.128 |
| Maximum | 4861.97 |
| Range | 3446.96 |
| Interquartile range (IQR) | 1497.96 |
Descriptive statistics
| Standard deviation | 861.7681297 |
|---|---|
| Coefficient of variation (CV) | 0.2843041462 |
| Kurtosis | -1.083984556 |
| Mean | 3031.148652 |
| Median Absolute Deviation (MAD) | 746.59 |
| Skewness | 0.129313889 |
| Sum | 508302410.9 |
| Variance | 742644.3093 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3340.5 | 59 | < 0.1% |
| 3123.84 | 52 | < 0.1% |
| 3224.79 | 51 | < 0.1% |
| 3262.7 | 40 | < 0.1% |
| 2923.7 | 37 | < 0.1% |
| 3182.15 | 32 | < 0.1% |
| 3300 | 32 | < 0.1% |
| 3006.59 | 28 | < 0.1% |
| 2596.44 | 28 | < 0.1% |
| 3067.63 | 27 | < 0.1% |
| Other values (109854) | 167307 |
| Value | Count | Frequency (%) |
| 1415.01 | 1 | |
| 1416.68 | 1 | |
| 1418.62 | 1 | |
| 1420.64 | 1 | |
| 1422.22 | 1 | |
| 1424.1 | 1 | |
| 1424.55 | 1 | |
| 1424.7 | 1 | |
| 1425.14 | 1 | |
| 1425.62 | 1 |
| Value | Count | Frequency (%) |
| 4861.97 | 2 | |
| 4860.45 | 1 | |
| 4855.18 | 1 | |
| 4853.49 | 1 | |
| 4853.17 | 1 | |
| 4851.02 | 1 | |
| 4850.85 | 1 | |
| 4850.14 | 1 | |
| 4850 | 1 | |
| 4849.8 | 1 |
| Distinct | 106082 |
|---|---|
| Distinct (%) | 63.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3033.034522 |
| Minimum | 1415.01 |
|---|---|
| Maximum | 4864.53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1415.01 |
|---|---|
| 5-th percentile | 1772.336 |
| Q1 | 2293.05 |
| median | 3064.28 |
| Q3 | 3789.95 |
| 95-th percentile | 4444.18 |
| Maximum | 4864.53 |
| Range | 3449.52 |
| Interquartile range (IQR) | 1496.9 |
Descriptive statistics
| Standard deviation | 861.8730925 |
|---|---|
| Coefficient of variation (CV) | 0.2841619791 |
| Kurtosis | -1.08339271 |
| Mean | 3033.034522 |
| Median Absolute Deviation (MAD) | 746.28 |
| Skewness | 0.1285407293 |
| Sum | 508618658.2 |
| Variance | 742825.2276 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3340.5 | 59 | < 0.1% |
| 3123.84 | 52 | < 0.1% |
| 3224.79 | 51 | < 0.1% |
| 3262.7 | 39 | < 0.1% |
| 3300 | 38 | < 0.1% |
| 2923.7 | 36 | < 0.1% |
| 3182.15 | 32 | < 0.1% |
| 2140 | 31 | < 0.1% |
| 2668.94 | 31 | < 0.1% |
| 2456.96 | 29 | < 0.1% |
| Other values (106072) | 167295 |
| Value | Count | Frequency (%) |
| 1415.01 | 1 | |
| 1416.68 | 1 | |
| 1418.62 | 1 | |
| 1420.64 | 1 | |
| 1424.55 | 1 | |
| 1424.7 | 1 | |
| 1425.62 | 1 | |
| 1426.57 | 1 | |
| 1426.64 | 1 | |
| 1427.19 | 1 |
| Value | Count | Frequency (%) |
| 4864.53 | 1 | |
| 4863.25 | 1 | |
| 4861.97 | 1 | |
| 4860.45 | 1 | |
| 4860 | 1 | |
| 4859.4 | 1 | |
| 4857.42 | 1 | |
| 4856.83 | 1 | |
| 4853.91 | 1 | |
| 4853.49 | 1 |
| Distinct | 106512 |
|---|---|
| Distinct (%) | 63.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3028.993787 |
| Minimum | 1320 |
|---|---|
| Maximum | 4858.83 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1320 |
|---|---|
| 5-th percentile | 1770.57 |
| Q1 | 2287.97 |
| median | 3060.74 |
| Q3 | 3786.12 |
| 95-th percentile | 4441.18 |
| Maximum | 4858.83 |
| Range | 3538.83 |
| Interquartile range (IQR) | 1498.15 |
Descriptive statistics
| Standard deviation | 861.591016 |
|---|---|
| Coefficient of variation (CV) | 0.284447931 |
| Kurtosis | -1.08446744 |
| Mean | 3028.993787 |
| Median Absolute Deviation (MAD) | 747.08 |
| Skewness | 0.1300496673 |
| Sum | 507941055.2 |
| Variance | 742339.0788 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3340.5 | 59 | < 0.1% |
| 3123.84 | 52 | < 0.1% |
| 3224.79 | 52 | < 0.1% |
| 3262.7 | 41 | < 0.1% |
| 2923.7 | 36 | < 0.1% |
| 2596.44 | 32 | < 0.1% |
| 3182.15 | 32 | < 0.1% |
| 2568.73 | 31 | < 0.1% |
| 3006.59 | 29 | < 0.1% |
| 3300 | 28 | < 0.1% |
| Other values (106502) | 167301 |
| Value | Count | Frequency (%) |
| 1320 | 1 | |
| 1413.51 | 1 | |
| 1413.88 | 1 | |
| 1416.68 | 1 | |
| 1418.62 | 1 | |
| 1422.22 | 1 | |
| 1423.63 | 1 | |
| 1423.86 | 1 | |
| 1424.55 | 1 | |
| 1424.7 | 1 |
| Value | Count | Frequency (%) |
| 4858.83 | 1 | |
| 4853.9 | 1 | |
| 4851.02 | 1 | |
| 4849.05 | 1 | |
| 4848.97 | 1 | |
| 4848.39 | 1 | |
| 4848.38 | 1 | |
| 4847.85 | 1 | |
| 4847.84 | 1 | |
| 4846.67 | 1 |
| Distinct | 102300 |
|---|---|
| Distinct (%) | 61.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3031.053097 |
| Minimum | 1413.51 |
|---|---|
| Maximum | 4858.83 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1413.51 |
|---|---|
| 5-th percentile | 1771.33 |
| Q1 | 2290.43 |
| median | 3062.43 |
| Q3 | 3788.18 |
| 95-th percentile | 4442.644 |
| Maximum | 4858.83 |
| Range | 3445.32 |
| Interquartile range (IQR) | 1497.75 |
Descriptive statistics
| Standard deviation | 861.7340972 |
|---|---|
| Coefficient of variation (CV) | 0.2843018811 |
| Kurtosis | -1.083983989 |
| Mean | 3031.053097 |
| Median Absolute Deviation (MAD) | 746.68 |
| Skewness | 0.1292738289 |
| Sum | 508286387 |
| Variance | 742585.6543 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3340.5 | 60 | < 0.1% |
| 3224.79 | 52 | < 0.1% |
| 3123.84 | 52 | < 0.1% |
| 3262.7 | 40 | < 0.1% |
| 3300 | 38 | < 0.1% |
| 2923.7 | 36 | < 0.1% |
| 3182.15 | 32 | < 0.1% |
| 2596.44 | 29 | < 0.1% |
| 2568.73 | 28 | < 0.1% |
| 2668.94 | 28 | < 0.1% |
| Other values (102290) | 167298 |
| Value | Count | Frequency (%) |
| 1413.51 | 1 | |
| 1413.88 | 1 | |
| 1416.68 | 1 | |
| 1418.62 | 1 | |
| 1423.33 | 1 | |
| 1424.55 | 1 | |
| 1424.7 | 1 | |
| 1424.74 | 1 | |
| 1424.94 | 1 | |
| 1424.95 | 1 |
| Value | Count | Frequency (%) |
| 4858.83 | 1 | |
| 4855.67 | 1 | |
| 4853.9 | 1 | |
| 4852.83 | 1 | |
| 4851.12 | 1 | |
| 4851.02 | 2 | |
| 4850.91 | 1 | |
| 4850.87 | 1 | |
| 4850.41 | 1 | |
| 4850.19 | 1 |
volume
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 98498 |
|---|---|
| Distinct (%) | 58.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.197698078 |
| Minimum | 0 |
|---|---|
| Maximum | 739.03261 |
| Zeros | 33414 |
| Zeros (%) | 19.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.0249 |
| median | 1.03538 |
| Q3 | 3.4964 |
| 95-th percentile | 12.593764 |
| Maximum | 739.03261 |
| Range | 739.03261 |
| Interquartile range (IQR) | 3.4715 |
Descriptive statistics
| Standard deviation | 8.05923681 |
|---|---|
| Coefficient of variation (CV) | 2.5203245 |
| Kurtosis | 1087.809066 |
| Mean | 3.197698078 |
| Median Absolute Deviation (MAD) | 1.03538 |
| Skewness | 20.69985771 |
| Sum | 536231.5837 |
| Variance | 64.95129796 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 33414 | 19.9% |
| 1 | 331 | 0.2% |
| 0.5 | 254 | 0.2% |
| 0.4 | 219 | 0.1% |
| 0.6 | 203 | 0.1% |
| 0.2 | 191 | 0.1% |
| 0.05 | 189 | 0.1% |
| 0.0139 | 182 | 0.1% |
| 0.1 | 175 | 0.1% |
| 0.7 | 171 | 0.1% |
| Other values (98488) | 132364 |
| Value | Count | Frequency (%) |
| 0 | 33414 | |
| 1 × 10-5 | 4 | < 0.1% |
| 2 × 10-5 | 2 | < 0.1% |
| 3 × 10-5 | 1 | < 0.1% |
| 4 × 10-5 | 1 | < 0.1% |
| 5 × 10-5 | 1 | < 0.1% |
| 6 × 10-5 | 2 | < 0.1% |
| 8 × 10-5 | 1 | < 0.1% |
| 9 × 10-5 | 1 | < 0.1% |
| 0.0001 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 739.03261 | 1 | |
| 629.92252 | 1 | |
| 503.49054 | 1 | |
| 480.44094 | 1 | |
| 468.68257 | 1 | |
| 415.49919 | 1 | |
| 398.49465 | 1 | |
| 322.6957 | 1 | |
| 279.807 | 1 | |
| 273.81611 | 1 |
close_time
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 167693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.629688333 × 1012 |
| Minimum | 1.61455698 × 1012 |
|---|---|
| Maximum | 1.6447968 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1.61455698 × 1012 |
|---|---|
| 5-th percentile | 1.616071608 × 1012 |
| Q1 | 1.62213444 × 1012 |
| median | 1.62969732 × 1012 |
| Q3 | 1.63725066 × 1012 |
| 95-th percentile | 1.643287572 × 1012 |
| Maximum | 1.6447968 × 1012 |
| Range | 3.023982 × 1010 |
| Interquartile range (IQR) | 1.511622 × 1010 |
Descriptive statistics
| Standard deviation | 8729706728 |
|---|---|
| Coefficient of variation (CV) | 0.00535667253 |
| Kurtosis | -1.20006685 |
| Mean | 1.629688333 × 1012 |
| Median Absolute Deviation (MAD) | 7558200000 |
| Skewness | -0.001590850265 |
| Sum | 2.732873257 × 1017 |
| Variance | 7.620777956 × 1019 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1.63081134 × 1012 | 1 | < 0.1% |
| 1.64172888 × 1012 | 1 | < 0.1% |
| 1.63538226 × 1012 | 1 | < 0.1% |
| 1.64293974 × 1012 | 1 | < 0.1% |
| 1.62189612 × 1012 | 1 | < 0.1% |
| 1.62848592 × 1012 | 1 | < 0.1% |
| 1.63570788 × 1012 | 1 | < 0.1% |
| 1.61889822 × 1012 | 1 | < 0.1% |
| 1.63106298 × 1012 | 1 | < 0.1% |
| 1.61668944 × 1012 | 1 | < 0.1% |
| Other values (167683) | 167683 |
| Value | Count | Frequency (%) |
| 1.61455698 × 1012 | 1 | |
| 1.61455716 × 1012 | 1 | |
| 1.61455734 × 1012 | 1 | |
| 1.61455752 × 1012 | 1 | |
| 1.6145577 × 1012 | 1 | |
| 1.61455788 × 1012 | 1 | |
| 1.61455806 × 1012 | 1 | |
| 1.61455824 × 1012 | 1 | |
| 1.61455842 × 1012 | 1 | |
| 1.6145586 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.6447968 × 1012 | 1 | |
| 1.64479662 × 1012 | 1 | |
| 1.64479644 × 1012 | 1 | |
| 1.64479626 × 1012 | 1 | |
| 1.64479608 × 1012 | 1 | |
| 1.6447959 × 1012 | 1 | |
| 1.64479572 × 1012 | 1 | |
| 1.64479554 × 1012 | 1 | |
| 1.64479536 × 1012 | 1 | |
| 1.64479518 × 1012 | 1 |
quote_asset_volume
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 133837 |
|---|---|
| Distinct (%) | 79.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9299.26115 |
| Minimum | 0 |
|---|---|
| Maximum | 1536197.879 |
| Zeros | 33414 |
| Zeros (%) | 19.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 74.929608 |
| median | 2844.204384 |
| Q3 | 10252.18735 |
| 95-th percentile | 37044.20866 |
| Maximum | 1536197.879 |
| Range | 1536197.879 |
| Interquartile range (IQR) | 10177.25774 |
Descriptive statistics
| Standard deviation | 22851.17329 |
|---|---|
| Coefficient of variation (CV) | 2.457310631 |
| Kurtosis | 605.1538805 |
| Mean | 9299.26115 |
| Median Absolute Deviation (MAD) | 2844.204384 |
| Skewness | 16.25909648 |
| Sum | 1559421000 |
| Variance | 522176120.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 33414 | 19.9% |
| 26.11583 | 7 | < 0.1% |
| 26.451352 | 6 | < 0.1% |
| 26.513312 | 6 | < 0.1% |
| 22.5335 | 6 | < 0.1% |
| 26.426682 | 5 | < 0.1% |
| 43.339505 | 5 | < 0.1% |
| 20.553035 | 5 | < 0.1% |
| 12.13222 | 5 | < 0.1% |
| 43.081104 | 5 | < 0.1% |
| Other values (133827) | 134229 |
| Value | Count | Frequency (%) |
| 0 | 33414 | |
| 0.0169769 | 1 | < 0.1% |
| 0.0183274 | 1 | < 0.1% |
| 0.023557 | 1 | < 0.1% |
| 0.0330124 | 1 | < 0.1% |
| 0.036803 | 1 | < 0.1% |
| 0.0550491 | 1 | < 0.1% |
| 0.0653928 | 1 | < 0.1% |
| 0.0736836 | 1 | < 0.1% |
| 0.103698 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1536197.879 | 1 | |
| 1508185.435 | 1 | |
| 1379494.586 | 1 | |
| 1201363.126 | 1 | |
| 1043585.291 | 1 | |
| 991519.4857 | 1 | |
| 928001.9059 | 1 | |
| 898101.9168 | 1 | |
| 894888.6451 | 1 | |
| 894225.5229 | 1 |
number_of_trades
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 277 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.899286196 |
| Minimum | 0 |
|---|---|
| Maximum | 1046 |
| Zeros | 33414 |
| Zeros (%) | 19.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 11 |
| 95-th percentile | 33 |
| Maximum | 1046 |
| Range | 1046 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 16.10302781 |
|---|---|
| Coefficient of variation (CV) | 1.809474092 |
| Kurtosis | 297.0969966 |
| Mean | 8.899286196 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 9.693089299 |
| Sum | 1492348 |
| Variance | 259.3075045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 33414 | |
| 1 | 20326 | |
| 2 | 14595 | 8.7% |
| 3 | 11669 | 7.0% |
| 4 | 9635 | 5.7% |
| 5 | 7936 | 4.7% |
| 6 | 6918 | 4.1% |
| 7 | 5976 | 3.6% |
| 8 | 5288 | 3.2% |
| 9 | 4617 | 2.8% |
| Other values (267) | 47319 |
| Value | Count | Frequency (%) |
| 0 | 33414 | |
| 1 | 20326 | |
| 2 | 14595 | |
| 3 | 11669 | 7.0% |
| 4 | 9635 | 5.7% |
| 5 | 7936 | 4.7% |
| 6 | 6918 | 4.1% |
| 7 | 5976 | 3.6% |
| 8 | 5288 | 3.2% |
| 9 | 4617 | 2.8% |
| Value | Count | Frequency (%) |
| 1046 | 1 | |
| 914 | 1 | |
| 767 | 1 | |
| 746 | 1 | |
| 696 | 1 | |
| 419 | 1 | |
| 404 | 1 | |
| 390 | 1 | |
| 385 | 1 | |
| 362 | 1 |
taker_buy_base_asset_volume
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 66978 |
|---|---|
| Distinct (%) | 39.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.518533806 |
| Minimum | 0 |
|---|---|
| Maximum | 629.4356 |
| Zeros | 70012 |
| Zeros (%) | 41.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.0629 |
| Q3 | 1.2877 |
| 95-th percentile | 6.672394 |
| Maximum | 629.4356 |
| Range | 629.4356 |
| Interquartile range (IQR) | 1.2877 |
Descriptive statistics
| Standard deviation | 5.519537423 |
|---|---|
| Coefficient of variation (CV) | 3.634780734 |
| Kurtosis | 1792.726341 |
| Mean | 1.518533806 |
| Median Absolute Deviation (MAD) | 0.0629 |
| Skewness | 27.29847463 |
| Sum | 254647.4896 |
| Variance | 30.46529336 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 70012 | |
| 0.5 | 327 | 0.2% |
| 1 | 318 | 0.2% |
| 0.4 | 255 | 0.2% |
| 0.6 | 243 | 0.1% |
| 0.65 | 221 | 0.1% |
| 0.7 | 217 | 0.1% |
| 0.1 | 204 | 0.1% |
| 0.3 | 198 | 0.1% |
| 0.05 | 194 | 0.1% |
| Other values (66968) | 95504 |
| Value | Count | Frequency (%) |
| 0 | 70012 | |
| 1 × 10-5 | 3 | < 0.1% |
| 2 × 10-5 | 2 | < 0.1% |
| 4 × 10-5 | 1 | < 0.1% |
| 7 × 10-5 | 3 | < 0.1% |
| 8 × 10-5 | 1 | < 0.1% |
| 0.0001 | 10 | < 0.1% |
| 0.00013 | 1 | < 0.1% |
| 0.00014 | 1 | < 0.1% |
| 0.00016 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 629.4356 | 1 | |
| 471.47823 | 1 | |
| 391.53518 | 1 | |
| 250.48332 | 1 | |
| 247.31307 | 1 | |
| 237.58096 | 1 | |
| 223.33321 | 1 | |
| 221.95032 | 1 | |
| 219.00216 | 1 | |
| 210.0272 | 1 |
taker_buy_quote_asset_volume
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 96935 |
|---|---|
| Distinct (%) | 57.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4376.024455 |
| Minimum | 0 |
|---|---|
| Maximum | 1507021.742 |
| Zeros | 70012 |
| Zeros (%) | 41.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 176.3552 |
| Q3 | 3555.792 |
| 95-th percentile | 20001.84303 |
| Maximum | 1507021.742 |
| Range | 1507021.742 |
| Interquartile range (IQR) | 3555.792 |
Descriptive statistics
| Standard deviation | 15685.6432 |
|---|---|
| Coefficient of variation (CV) | 3.584450536 |
| Kurtosis | 1092.031597 |
| Mean | 4376.024455 |
| Median Absolute Deviation (MAD) | 176.3552 |
| Skewness | 22.69475006 |
| Sum | 733828668.9 |
| Variance | 246039402.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 70012 | |
| 26.516962 | 9 | < 0.1% |
| 43.339505 | 8 | < 0.1% |
| 26.168025 | 8 | < 0.1% |
| 26.27928 | 8 | < 0.1% |
| 22.5335 | 7 | < 0.1% |
| 22.790355 | 7 | < 0.1% |
| 26.408547 | 7 | < 0.1% |
| 22.4270618 | 7 | < 0.1% |
| 26.205921 | 7 | < 0.1% |
| Other values (96925) | 97613 |
| Value | Count | Frequency (%) |
| 0 | 70012 | |
| 0.019655 | 1 | < 0.1% |
| 0.0330124 | 1 | < 0.1% |
| 0.0350742 | 1 | < 0.1% |
| 0.036803 | 1 | < 0.1% |
| 0.0478676 | 1 | < 0.1% |
| 0.0935672 | 1 | < 0.1% |
| 0.143204 | 1 | < 0.1% |
| 0.170753 | 1 | < 0.1% |
| 0.204722 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1507021.742 | 1 | |
| 878958.7224 | 1 | |
| 874219.4502 | 1 | |
| 840253.3005 | 1 | |
| 837964.8224 | 1 | |
| 804816.6844 | 1 | |
| 787409.9658 | 1 | |
| 666322.1358 | 1 | |
| 655168.9549 | 1 | |
| 636510.7665 | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 167693 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 167693 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 167693 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 167693 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 167693 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 167693 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 167693 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 167693 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 167693 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 167693 |
return
Real number (ℝ)
| Distinct | 156249 |
|---|---|
| Distinct (%) | 93.4% |
| Missing | 480 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.003216872948 |
| Minimum | -0.4134126678 |
|---|---|
| Maximum | 0.4627397083 |
| Zeros | 11 |
| Zeros (%) | < 0.1% |
| Negative | 77397 |
| Negative (%) | 46.2% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -0.4134126678 |
|---|---|
| 5-th percentile | -0.07872063596 |
| Q1 | -0.0250697918 |
| median | 0.004006037919 |
| Q3 | 0.03391047352 |
| 95-th percentile | 0.08089207883 |
| Maximum | 0.4627397083 |
| Range | 0.8761523761 |
| Interquartile range (IQR) | 0.05898026531 |
Descriptive statistics
| Standard deviation | 0.05083771007 |
|---|---|
| Coefficient of variation (CV) | 15.803456 |
| Kurtosis | 3.460966565 |
| Mean | 0.003216872948 |
| Median Absolute Deviation (MAD) | 0.02953656949 |
| Skewness | -0.1179855097 |
| Sum | 537.9029762 |
| Variance | 0.002584472765 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.002861847029 | 21 | < 0.1% |
| -0.01980653939 | 17 | < 0.1% |
| 0.03707528242 | 17 | < 0.1% |
| -0.03068661181 | 14 | < 0.1% |
| -0.01654311706 | 13 | < 0.1% |
| -0.01079416803 | 13 | < 0.1% |
| -0.06019551282 | 13 | < 0.1% |
| 0.005516458844 | 13 | < 0.1% |
| 0.03115241613 | 13 | < 0.1% |
| 0.01563735556 | 13 | < 0.1% |
| Other values (156239) | 167066 | |
| (Missing) | 480 | 0.3% |
| Value | Count | Frequency (%) |
| -0.4134126678 | 1 | |
| -0.4080989784 | 1 | |
| -0.4038134141 | 1 | |
| -0.3723921569 | 1 | |
| -0.3663794359 | 1 | |
| -0.3648034878 | 1 | |
| -0.3551193677 | 1 | |
| -0.3548069743 | 1 | |
| -0.3539588497 | 1 | |
| -0.3539423946 | 1 |
| Value | Count | Frequency (%) |
| 0.4627397083 | 1 | |
| 0.4322225499 | 1 | |
| 0.4261692947 | 1 | |
| 0.4218145721 | 1 | |
| 0.41724474 | 1 | |
| 0.3881221508 | 1 | |
| 0.3802125549 | 1 | |
| 0.3776508703 | 1 | |
| 0.3774813661 | 1 | |
| 0.3763396057 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| open time | open | high | low | close | volume | close_time | quote_asset_volume | number_of_trades | taker_buy_base_asset_volume | taker_buy_quote_asset_volume | ignore | return | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1614556800000 | 1422.22 | 1429.47 | 1422.22 | 1423.33 | 4.21026 | 1614556979999 | 6009.598029 | 8 | 2.76588 | 3945.181854 | 0 | NaN |
| 1 | 1614556980000 | 1420.64 | 1420.64 | 1413.88 | 1413.88 | 11.07088 | 1614557159999 | 15683.606427 | 13 | 0.14750 | 209.421975 | 0 | NaN |
| 2 | 1614557160000 | 1415.01 | 1415.01 | 1413.51 | 1413.51 | 6.42969 | 1614557339999 | 9091.381863 | 9 | 0.00000 | 0.000000 | 0 | NaN |
| 3 | 1614557340000 | 1416.68 | 1416.68 | 1416.68 | 1416.68 | 1.20000 | 1614557519999 | 1700.016000 | 1 | 0.00000 | 0.000000 | 0 | NaN |
| 4 | 1614557520000 | 1418.62 | 1418.62 | 1418.62 | 1418.62 | 0.01992 | 1614557699999 | 28.258910 | 1 | 0.00000 | 0.000000 | 0 | NaN |
| 5 | 1614557700000 | 1425.65 | 1445.86 | 1425.65 | 1445.86 | 3.61788 | 1614557879999 | 5213.791001 | 5 | 3.47139 | 5004.947533 | 0 | NaN |
| 6 | 1614557880000 | 1444.44 | 1444.44 | 1443.57 | 1443.57 | 3.75392 | 1614558059999 | 5420.242554 | 4 | 0.00000 | 0.000000 | 0 | NaN |
| 7 | 1614558060000 | 1441.27 | 1441.27 | 1441.27 | 1441.27 | 0.01790 | 1614558239999 | 25.798733 | 2 | 0.00895 | 12.899366 | 0 | NaN |
| 8 | 1614558240000 | 1441.27 | 1441.27 | 1441.27 | 1441.27 | 0.00000 | 1614558419999 | 0.000000 | 0 | 0.00000 | 0.000000 | 0 | NaN |
| 9 | 1614558420000 | 1441.77 | 1441.77 | 1441.77 | 1441.77 | 1.29914 | 1614558599999 | 1873.061078 | 1 | 0.00000 | 0.000000 | 0 | NaN |
Last rows
| open time | open | high | low | close | volume | close_time | quote_asset_volume | number_of_trades | taker_buy_base_asset_volume | taker_buy_quote_asset_volume | ignore | return | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167683 | 1644795000000 | 2879.87 | 2879.87 | 2879.87 | 2879.87 | 0.1736 | 1644795179999 | 499.945432 | 1 | 0.0000 | 0.000000 | 0 | -0.012881 |
| 167684 | 1644795180000 | 2879.87 | 2879.87 | 2879.87 | 2879.87 | 0.0000 | 1644795359999 | 0.000000 | 0 | 0.0000 | 0.000000 | 0 | -0.012881 |
| 167685 | 1644795360000 | 2879.87 | 2879.87 | 2879.87 | 2879.87 | 0.0000 | 1644795539999 | 0.000000 | 0 | 0.0000 | 0.000000 | 0 | -0.006729 |
| 167686 | 1644795540000 | 2877.43 | 2877.43 | 2877.43 | 2877.43 | 0.2038 | 1644795719999 | 586.420234 | 2 | 0.2038 | 586.420234 | 0 | -0.007571 |
| 167687 | 1644795720000 | 2878.58 | 2878.58 | 2878.58 | 2878.58 | 3.4748 | 1644795899999 | 10002.489784 | 5 | 3.4748 | 10002.489784 | 0 | -0.007174 |
| 167688 | 1644795900000 | 2882.67 | 2890.48 | 2882.67 | 2890.48 | 3.4838 | 1644796079999 | 10042.754305 | 3 | 3.4838 | 10042.754305 | 0 | -0.003070 |
| 167689 | 1644796080000 | 2890.48 | 2890.48 | 2890.48 | 2890.48 | 0.0000 | 1644796259999 | 0.000000 | 0 | 0.0000 | 0.000000 | 0 | -0.003070 |
| 167690 | 1644796260000 | 2890.48 | 2890.48 | 2890.48 | 2890.48 | 0.0000 | 1644796439999 | 0.000000 | 0 | 0.0000 | 0.000000 | 0 | -0.003070 |
| 167691 | 1644796440000 | 2889.42 | 2889.42 | 2888.43 | 2888.43 | 0.1870 | 1644796619999 | 540.150171 | 3 | 0.0139 | 40.162938 | 0 | -0.003777 |
| 167692 | 1644796620000 | 2873.25 | 2873.25 | 2873.25 | 2873.25 | 0.0139 | 1644796799999 | 39.938175 | 1 | 0.0000 | 0.000000 | 0 | -0.009012 |